# Add district code for each county in Texas. 


BEGIN {
  FS = ","
  OFS = ","
  while ((getline line < "D:/research/Green_jobs/data/TX/RRC_dist_code_TX.csv") > 0 ) {
    split (line, x)
    county = x[1]
    dist[county] = x[2]
  }
}

{
  if ($1 in dist)
    print dist[$1], $0
  else {
    print NR, $1, "Error"
    exit
   }
}


